﻿CREATE TABLE [dbo].[vw_MasterQuery_ALL_CurrentYear] (
    [PeriodYear]                     INT              NULL,
    [Account_Level_1]                VARCHAR (25)     NULL,
    [Account_Level_2]                VARCHAR (25)     NULL,
    [Account_Level_3]                VARCHAR (25)     NULL,
    [Initiative_Id]                  VARCHAR (30)     NULL,
    [INITIATIVE_NAME]                VARCHAR (255)    NULL,
    [Program_Id]                     VARCHAR (30)     NULL,
    [PROGRAM_NAME]                   VARCHAR (255)    NULL,
    [Project_Id]                     VARCHAR (10)     NULL,
    [PROJECT_NAME]                   VARCHAR (200)    NULL,
    [Program_Manager]                VARCHAR (255)    NULL,
    [PROG_START_DATE]                DATETIME         NULL,
    [PROG_END_DATE]                  DATETIME         NULL,
    [PROJECT_STATUS]                 VARCHAR (100)    NULL,
    [PROJECT_START_DATE]             DATETIME         NULL,
    [PROJECT_END_DATE]               DATETIME         NULL,
    [PROJECT_MANAGER]                VARCHAR (150)    NULL,
    [Billing_Client_Goc_Code]        VARCHAR (15)     NULL,
    [Client_3_name]                  VARCHAR (120)    NULL,
    [Client_4_name]                  VARCHAR (120)    NULL,
    [Client_5_name]                  VARCHAR (120)    NULL,
    [Client_6_name]                  VARCHAR (120)    NULL,
    [Client_7_name]                  VARCHAR (120)    NULL,
    [Client_8_name]                  VARCHAR (120)    NULL,
    [Client_9_name]                  VARCHAR (120)    NULL,
    [Client_10_NAME]                 VARCHAR (120)    NULL,
    [CLIENT_GOC_CODE]                VARCHAR (15)     NULL,
    [Client_Region]                  VARCHAR (64)     NULL,
    [System_5_name]                  VARCHAR (120)    NULL,
    [System_6_name]                  VARCHAR (120)    NULL,
    [System_7_name]                  VARCHAR (120)    NULL,
    [System_8_name]                  VARCHAR (120)    NULL,
    [System_9_name]                  VARCHAR (120)    NULL,
    [System_10_name]                 VARCHAR (120)    NULL,
    [SYSTEM_GOC_CODE]                VARCHAR (15)     NULL,
    [System_Region]                  VARCHAR (64)     NULL,
    [LOB]                            VARCHAR (250)    NULL,
    [RuntheBankBuildtheBank]         VARCHAR (1)      NULL,
    [PROGRAM_PROJECT_LINK_INDICATOR] VARCHAR (10)     NULL,
    [Work Type Financials]           VARCHAR (18)     NULL,
    [INIT_INVEST_CATEGORY]           VARCHAR (186)    NULL,
    [PROG_INVEST_CATEGORY]           VARCHAR (50)     NULL,
    [PROG_CAPIND]                    CHAR (1)         NULL,
    [PROGRAM_STATUS]                 VARCHAR (50)     NULL,
    [Project_Capitalization]         CHAR (1)         NULL,
    [BOW Flag]                       VARCHAR (10)     NULL,
    [BOW Flag2]                      VARCHAR (10)     NULL,
    [Project_Type]                   VARCHAR (100)    NULL,
    [PROGRAM_CARRYOVER_INDICATOR]    CHAR (1)         NULL,
    [TAXONOMYNAME]                   VARCHAR (100)    NULL,
    [CU_Rate]                        DECIMAL (9, 6)   NULL,
    [FirstOfPROGRAM_DESC]            VARCHAR (2000)   NULL,
    [Adjusted_Flag]                  VARCHAR (10)     NULL,
    [LOB_PARENT]                     VARCHAR (250)    NULL,
    [January]                        DECIMAL (38, 18) NULL,
    [February]                       DECIMAL (38, 18) NULL,
    [March]                          DECIMAL (38, 18) NULL,
    [April]                          DECIMAL (38, 18) NULL,
    [May]                            DECIMAL (38, 18) NULL,
    [June]                           DECIMAL (38, 18) NULL,
    [July]                           DECIMAL (38, 18) NULL,
    [August]                         DECIMAL (38, 18) NULL,
    [September]                      DECIMAL (38, 18) NULL,
    [October]                        DECIMAL (38, 18) NULL,
    [November]                       DECIMAL (38, 18) NULL,
    [December]                       DECIMAL (38, 18) NULL,
    [YearToDate]                     DECIMAL (38, 18) NULL,
    [FullYear]                       DECIMAL (38, 18) NULL
);

